Pandas Profiling Report

Dataset statistics

Number of variables	15
Number of observations	4300713
Missing cells	21638956
Missing cells (%)	33.5%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	492.2 MiB
Average record size in memory	120.0 B

Variable types

Categorical	8
Numeric	7

Warnings

`country_region_code` has a high cardinality: 134 distinct values	High cardinality
`country_region` has a high cardinality: 135 distinct values	High cardinality
`sub_region_1` has a high cardinality: 1860 distinct values	High cardinality
`sub_region_2` has a high cardinality: 9915 distinct values	High cardinality
`metro_area` has a high cardinality: 65 distinct values	High cardinality
`iso_3166_2_code` has a high cardinality: 2224 distinct values	High cardinality
`place_id` has a high cardinality: 13276 distinct values	High cardinality
`date` has a high cardinality: 368 distinct values	High cardinality
`sub_region_1` has 73227 (1.7%) missing values	Missing
`sub_region_2` has 715894 (16.6%) missing values	Missing
`metro_area` has 4276928 (99.4%) missing values	Missing
`iso_3166_2_code` has 3531512 (82.1%) missing values	Missing
`census_fips_code` has 3384928 (78.7%) missing values	Missing
`retail_and_recreation` has 1598804 (37.2%) missing values	Missing
`grocery_and_pharmacy` has 1694251 (39.4%) missing values	Missing
`parks` has 2235583 (52.0%) missing values	Missing
`transit_stations` has 2127730 (49.5%) missing values	Missing
`workplaces` has 198009 (4.6%) missing values	Missing
`residential` has 1798617 (41.8%) missing values	Missing
`metro_area` is uniformly distributed	Uniform
`grocery_and_pharmacy` has 69501 (1.6%) zeros	Zeros
`workplaces` has 67235 (1.6%) zeros	Zeros
`residential` has 91313 (2.1%) zeros	Zeros

Reproduction

Analysis started	2021-03-02 09:16:42.551556
Analysis finished	2021-03-02 09:23:13.803285
Duration	6 minutes and 31.25 seconds
Software version	pandas-profiling v2.11.0
Download configuration	config.yaml

country_region_code
Categorical

HIGH CARDINALITY

Distinct	134
Distinct (%)	< 0.1%
Missing	2737
Missing (%)	0.1%
Memory size	32.8 MiB

US	934553
BR	692859
IN	244331
TR	194737
GB	153032
Other values (129)	2078464

Length

Max length	2
Median length	2
Mean length	2
Min length	2

Characters and Unicode

Total characters	8595952
Distinct characters	26
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	AE
2nd row	AE
3rd row	AE
4th row	AE
5th row	AE

Value	Count	Frequency (%)
US	934553	21.7%
BR	692859	16.1%
IN	244331	5.7%
TR	194737	4.5%
GB	153032	3.6%
AR	150987	3.5%
PL	139431	3.2%
NL	127361	3.0%
CO	116651	2.7%
AU	98814	2.3%
Other values (124)	1445220	33.6%

Histogram of lengths of the category

Value	Count	Frequency (%)
us	934553	21.7%
br	692859	16.1%
in	244331	5.7%
tr	194737	4.5%
gb	153032	3.6%
ar	150987	3.5%
pl	139431	3.2%
nl	127361	3.0%
co	116651	2.7%
au	98814	2.3%
Other values (124)	1445220	33.6%

Most occurring characters

Value	Count	Frequency (%)
R	1215135	14.1%
S	1128559	13.1%
U	1066841	12.4%
B	938709	10.9%
N	553100	6.4%
T	429985	5.0%
I	400834	4.7%
A	396127	4.6%
L	348550	4.1%
C	336102	3.9%
Other values (16)	1782010	20.7%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	8595952	100.0%

Most frequent character per category

Value	Count	Frequency (%)
R	1215135	14.1%
S	1128559	13.1%
U	1066841	12.4%
B	938709	10.9%
N	553100	6.4%
T	429985	5.0%
I	400834	4.7%
A	396127	4.6%
L	348550	4.1%
C	336102	3.9%
Other values (16)	1782010	20.7%

Most occurring scripts

Value	Count	Frequency (%)
Latin	8595952	100.0%

Most frequent character per script

Value	Count	Frequency (%)
R	1215135	14.1%
S	1128559	13.1%
U	1066841	12.4%
B	938709	10.9%
N	553100	6.4%
T	429985	5.0%
I	400834	4.7%
A	396127	4.6%
L	348550	4.1%
C	336102	3.9%
Other values (16)	1782010	20.7%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	8595952	100.0%

Most frequent character per block

Value	Count	Frequency (%)
R	1215135	14.1%
S	1128559	13.1%
U	1066841	12.4%
B	938709	10.9%
N	553100	6.4%
T	429985	5.0%
I	400834	4.7%
A	396127	4.6%
L	348550	4.1%
C	336102	3.9%
Other values (16)	1782010	20.7%

country_region
Categorical

HIGH CARDINALITY

Distinct	135
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	32.8 MiB

United States	934553
Brazil	692859
India	244331
Turkey	194737
United Kingdom	153032
Other values (130)	2081201

Length

Max length	22
Median length	7
Mean length	8.50622048
Min length	4

Characters and Unicode

Total characters	36582813
Distinct characters	57
Distinct categories	7 ?
Distinct scripts	2 ?
Distinct blocks	2 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	United Arab Emirates
2nd row	United Arab Emirates
3rd row	United Arab Emirates
4th row	United Arab Emirates
5th row	United Arab Emirates

Value	Count	Frequency (%)
United States	934553	21.7%
Brazil	692859	16.1%
India	244331	5.7%
Turkey	194737	4.5%
United Kingdom	153032	3.6%
Argentina	150987	3.5%
Poland	139431	3.2%
Netherlands	127361	3.0%
Colombia	116651	2.7%
Australia	98814	2.3%
Other values (125)	1447957	33.7%

Histogram of lengths of the category

Value	Count	Frequency (%)
united	1090522	20.0%
states	934553	17.1%
brazil	692859	12.7%
india	244331	4.5%
turkey	194737	3.6%
kingdom	153032	2.8%
argentina	150987	2.8%
poland	139431	2.6%
netherlands	127361	2.3%
colombia	116651	2.1%
Other values (147)	1621151	29.7%

Most occurring characters

Value	Count	Frequency (%)
a	4459300	12.2%
t	3678259	10.1%
i	3427324	9.4%
e	3369243	9.2%
n	2846412	7.8%
d	2110345	5.8%
r	1876235	5.1%
l	1597440	4.4%
s	1298608	3.5%
	1164902	3.2%
Other values (47)	10754745	29.4%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	29947345	81.9%
Uppercase Letter	5463724	14.9%
Space Separator	1164902	3.2%
Other Punctuation	4291	< 0.1%
Open Punctuation	1104	< 0.1%
Close Punctuation	1104	< 0.1%
Dash Punctuation	343	< 0.1%

Most frequent character per category

Value	Count	Frequency (%)
a	4459300	14.9%
t	3678259	12.3%
i	3427324	11.4%
e	3369243	11.3%
n	2846412	9.5%
d	2110345	7.0%
r	1876235	6.3%
l	1597440	5.3%
s	1298608	4.3%
o	1066760	3.6%
Other values (18)	4217419	14.1%

Value	Count	Frequency (%)
S	1141549	20.9%
U	1105753	20.2%
B	774886	14.2%
I	325744	6.0%
P	301515	5.5%
A	300808	5.5%
C	294625	5.4%
N	264308	4.8%
T	218315	4.0%
K	174525	3.2%
Other values (14)	561696	10.3%

Value	Count	Frequency (%)
	1164902	100.0%

Value	Count	Frequency (%)
'	4291	100.0%

Value	Count	Frequency (%)
-	343	100.0%

Value	Count	Frequency (%)
(	1104	100.0%

Value	Count	Frequency (%)
)	1104	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	35411069	96.8%
Common	1171744	3.2%

Most frequent character per script

Value	Count	Frequency (%)
a	4459300	12.6%
t	3678259	10.4%
i	3427324	9.7%
e	3369243	9.5%
n	2846412	8.0%
d	2110345	6.0%
r	1876235	5.3%
l	1597440	4.5%
s	1298608	3.7%
S	1141549	3.2%
Other values (42)	9606354	27.1%

Value	Count	Frequency (%)
	1164902	99.4%
'	4291	0.4%
(	1104	0.1%
)	1104	0.1%
-	343	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	36577668	> 99.9%
None	5145	< 0.1%

Most frequent character per block

Value	Count	Frequency (%)
a	4459300	12.2%
t	3678259	10.1%
i	3427324	9.4%
e	3369243	9.2%
n	2846412	7.8%
d	2110345	5.8%
r	1876235	5.1%
l	1597440	4.4%
s	1298608	3.6%
	1164902	3.2%
Other values (45)	10749600	29.4%

Value	Count	Frequency (%)
ô	4291	83.4%
é	854	16.6%

sub_region_1
Categorical

HIGH CARDINALITY
MISSING

Distinct	1860
Distinct (%)	< 0.1%
Missing	73227
Missing (%)	1.7%
Memory size	32.8 MiB

State of São Paulo	129391
State of Minas Gerais	89699
Texas	68947
State of Rio Grande do Sul	53386
State of Paraná	52646
Other values (1855)	3833417

Length

Max length	74
Median length	12
Mean length	12.55948807
Min length	3

Characters and Unicode

Total characters	53095060
Distinct characters	122
Distinct categories	6 ?
Distinct scripts	3 ?
Distinct blocks	4 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	2 ?
Unique (%)	< 0.1%

Sample

1st row	Abu Dhabi
2nd row	Abu Dhabi
3rd row	Abu Dhabi
4th row	Abu Dhabi
5th row	Abu Dhabi

Value	Count	Frequency (%)
State of São Paulo	129391	3.0%
State of Minas Gerais	89699	2.1%
Texas	68947	1.6%
State of Rio Grande do Sul	53386	1.2%
State of Paraná	52646	1.2%
Georgia	48680	1.1%
State of Bahia	48475	1.1%
Buenos Aires Province	45072	1.0%
State of Santa Catarina	43505	1.0%
Virginia	43463	1.0%
Other values (1850)	3604222	83.8%
(Missing)	73227	1.7%

Histogram of lengths of the category

Value	Count	Frequency (%)
of	719153	8.9%
state	697350	8.6%
county	222079	2.7%
province	168491	2.1%
voivodeship	139063	1.7%
region	138620	1.7%
são	129735	1.6%
paulo	129391	1.6%
south	103530	1.3%
north	102582	1.3%
Other values (1969)	5567248	68.6%

Most occurring characters

Value	Count	Frequency (%)
a	6209722	11.7%
o	4250463	8.0%
e	3917832	7.4%
	3889756	7.3%
t	3576739	6.7%
i	3528111	6.6%
n	3391133	6.4%
r	3024856	5.7%
s	2209305	4.2%
l	1495264	2.8%
Other values (112)	17601879	33.2%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	41794233	78.7%
Uppercase Letter	7308263	13.8%
Space Separator	3889756	7.3%
Dash Punctuation	93787	0.2%
Other Punctuation	8653	< 0.1%
Format	368	< 0.1%

Most frequent character per category

Value	Count	Frequency (%)
a	6209722	14.9%
o	4250463	10.2%
e	3917832	9.4%
t	3576739	8.6%
i	3528111	8.4%
n	3391133	8.1%
r	3024856	7.2%
s	2209305	5.3%
l	1495264	3.6%
u	1457779	3.5%
Other values (65)	8733029	20.9%

Value	Count	Frequency (%)
S	1346050	18.4%
P	682467	9.3%
C	656395	9.0%
M	512113	7.0%
G	439248	6.0%
A	372370	5.1%
V	338401	4.6%
R	320626	4.4%
N	320299	4.4%
B	300446	4.1%
Other values (31)	2019848	27.6%

Value	Count	Frequency (%)
'	4692	54.2%
.	2860	33.1%
,	1101	12.7%

Value	Count	Frequency (%)
	3889756	100.0%

Value	Count	Frequency (%)
-	93787	100.0%

Value	Count	Frequency (%)
‍	368	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	49102496	92.5%
Common	3992196	7.5%
Inherited	368	< 0.1%

Most frequent character per script

Value	Count	Frequency (%)
a	6209722	12.6%
o	4250463	8.7%
e	3917832	8.0%
t	3576739	7.3%
i	3528111	7.2%
n	3391133	6.9%
r	3024856	6.2%
s	2209305	4.5%
l	1495264	3.0%
u	1457779	3.0%
Other values (106)	16041292	32.7%

Value	Count	Frequency (%)
	3889756	97.4%
-	93787	2.3%
'	4692	0.1%
.	2860	0.1%
,	1101	< 0.1%

Value	Count	Frequency (%)
‍	368	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	52336167	98.6%
None	754139	1.4%
Latin Ext Additional	4386	< 0.1%
Punctuation	368	< 0.1%

Most frequent character per block

Value	Count	Frequency (%)
a	6209722	11.9%
o	4250463	8.1%
e	3917832	7.5%
	3889756	7.4%
t	3576739	6.8%
i	3528111	6.7%
n	3391133	6.5%
r	3024856	5.8%
s	2209305	4.2%
l	1495264	2.9%
Other values (46)	16842986	32.2%

Value	Count	Frequency (%)
á	165278	21.9%
ã	144668	19.2%
í	64570	8.6%
ı	28765	3.8%
é	28449	3.8%
İ	24770	3.3%
ä	23601	3.1%
ș	21860	2.9%
ö	20487	2.7%
ó	17226	2.3%
Other values (48)	214465	28.4%

Value	Count	Frequency (%)
‍	368	100.0%

Value	Count	Frequency (%)
ắ	1089	24.8%
ồ	736	16.8%
ả	736	16.8%
ạ	721	16.4%
ậ	368	8.4%
ầ	368	8.4%
ị	368	8.4%

sub_region_2
Categorical

HIGH CARDINALITY
MISSING

Distinct	9915
Distinct (%)	0.3%
Missing	715894
Missing (%)	16.6%
Memory size	32.8 MiB

Washington County	9789
Jefferson County	8108
Franklin County	7658
Jackson County	7003
Lincoln County	6685
Other values (9910)	3545576

Length

Max length	56
Median length	13
Mean length	13.21418571
Min length	2

Characters and Unicode

Total characters	47370464
Distinct characters	141
Distinct categories	6 ?
Distinct scripts	2 ?
Distinct blocks	3 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	4 ?
Unique (%)	< 0.1%

Sample

1st row	Comuna 1
2nd row	Comuna 1
3rd row	Comuna 1
4th row	Comuna 1
5th row	Comuna 1

Value	Count	Frequency (%)
Washington County	9789	0.2%
Jefferson County	8108	0.2%
Franklin County	7658	0.2%
Jackson County	7003	0.2%
Lincoln County	6685	0.2%
Madison County	6409	0.1%
Montgomery County	5941	0.1%
Marion County	5592	0.1%
Monroe County	5373	0.1%
Union County	5372	0.1%
Other values (9905)	3516889	81.8%
(Missing)	715894	16.6%

Histogram of lengths of the category

Value	Count	Frequency (%)
county	1029129	15.4%
municipality	208758	3.1%
district	158550	2.4%
of	118373	1.8%
department	88696	1.3%
province	83612	1.3%
do	63457	1.0%
de	61494	0.9%
city	59400	0.9%
são	39911	0.6%
Other values (9635)	4764709	71.4%

Most occurring characters

Value	Count	Frequency (%)
a	4289551	9.1%
o	3646235	7.7%
n	3542846	7.5%
i	3188962	6.7%
	3091558	6.5%
t	3063376	6.5%
e	2838905	6.0%
r	2642997	5.6%
u	2341440	4.9%
l	1669866	3.5%
Other values (131)	17054728	36.0%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	37669287	79.5%
Uppercase Letter	6393647	13.5%
Space Separator	3091558	6.5%
Dash Punctuation	123940	0.3%
Other Punctuation	52708	0.1%
Decimal Number	39324	0.1%

Most frequent character per category

Value	Count	Frequency (%)
a	4289551	11.4%
o	3646235	9.7%
n	3542846	9.4%
i	3188962	8.5%
t	3063376	8.1%
e	2838905	7.5%
r	2642997	7.0%
u	2341440	6.2%
l	1669866	4.4%
y	1589866	4.2%
Other values (64)	8855243	23.5%

Value	Count	Frequency (%)
C	1560055	24.4%
M	582116	9.1%
S	490442	7.7%
P	451553	7.1%
D	405086	6.3%
B	340117	5.3%
L	244731	3.8%
A	244650	3.8%
R	209866	3.3%
G	208229	3.3%
Other values (38)	1656802	25.9%

Value	Count	Frequency (%)
1	15150	38.5%
2	5111	13.0%
5	3048	7.8%
4	2707	6.9%
7	2637	6.7%
3	2585	6.6%
8	2277	5.8%
9	2229	5.7%
6	2149	5.5%
0	1431	3.6%

Value	Count	Frequency (%)
.	30454	57.8%
'	10936	20.7%
,	7920	15.0%
/	3030	5.7%
&	368	0.7%

Value	Count	Frequency (%)
-	123007	99.2%
–	592	0.5%
—	341	0.3%

Value	Count	Frequency (%)
	3091558	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	44062934	93.0%
Common	3307530	7.0%

Most frequent character per script

Value	Count	Frequency (%)
a	4289551	9.7%
o	3646235	8.3%
n	3542846	8.0%
i	3188962	7.2%
t	3063376	7.0%
e	2838905	6.4%
r	2642997	6.0%
u	2341440	5.3%
l	1669866	3.8%
y	1589866	3.6%
Other values (112)	15248890	34.6%

Value	Count	Frequency (%)
	3091558	93.5%
-	123007	3.7%
.	30454	0.9%
1	15150	0.5%
'	10936	0.3%
,	7920	0.2%
2	5111	0.2%
5	3048	0.1%
/	3030	0.1%
4	2707	0.1%
Other values (9)	14609	0.4%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	46553939	98.3%
None	815592	1.7%
Punctuation	933	< 0.1%

Most frequent character per block

Value	Count	Frequency (%)
a	4289551	9.2%
o	3646235	7.8%
n	3542846	7.6%
i	3188962	6.9%
	3091558	6.6%
t	3063376	6.6%
e	2838905	6.1%
r	2642997	5.7%
u	2341440	5.0%
l	1669866	3.6%
Other values (59)	16238203	34.9%

Value	Count	Frequency (%)
ã	85481	10.5%
á	83885	10.3%
ó	75673	9.3%
í	71941	8.8%
é	66464	8.1%
ç	47131	5.8%
ı	34176	4.2%
ö	30393	3.7%
ł	24462	3.0%
ú	22359	2.7%
Other values (60)	273627	33.5%

Value	Count	Frequency (%)
–	592	63.5%
—	341	36.5%

metro_area
Categorical

HIGH CARDINALITY
MISSING
UNIFORM

Distinct	65
Distinct (%)	0.3%
Missing	4276928
Missing (%)	99.4%
Memory size	32.8 MiB

Port-au-Prince Metropolitan Area	368
Naimey Metropolitan Area	368
Davao City Metropolitan Area	368
Eldoret Metropolitan Area	368
Casablanca Metropolitan Area	368
Other values (60)	21945

Length

Max length	34
Median length	25
Mean length	25.6671852
Min length	21

Characters and Unicode

Total characters	610494
Distinct characters	48
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Kabul Metropolitan Area
2nd row	Kabul Metropolitan Area
3rd row	Kabul Metropolitan Area
4th row	Kabul Metropolitan Area
5th row	Kabul Metropolitan Area

Value	Count	Frequency (%)
Port-au-Prince Metropolitan Area	368	< 0.1%
Naimey Metropolitan Area	368	< 0.1%
Davao City Metropolitan Area	368	< 0.1%
Eldoret Metropolitan Area	368	< 0.1%
Casablanca Metropolitan Area	368	< 0.1%
Sargodha Metropolitan Area	368	< 0.1%
Chelyabinsk Metropolitan Area	368	< 0.1%
Bamako Metropolitan Area	368	< 0.1%
Bacolod Metropolitan Area	368	< 0.1%
Voronezh Metropolitan Area	368	< 0.1%
Other values (55)	20105	0.5%
(Missing)	4276928	99.4%

Histogram of lengths of the category

Value	Count	Frequency (%)
area	23785	32.2%
metropolitan	23785	32.2%
city	1104	1.5%
voronezh	368	0.5%
mombasa	368	0.5%
bacolod	368	0.5%
nairobi	368	0.5%
doha	368	0.5%
yangon	368	0.5%
pampanga	368	0.5%
Other values (62)	22681	30.7%

Most occurring characters

Value	Count	Frequency (%)
a	78760	12.9%
o	61554	10.1%
r	58565	9.6%
e	56680	9.3%
t	54194	8.9%
	50146	8.2%
i	34322	5.6%
n	33353	5.5%
l	30274	5.0%
M	26729	4.4%
Other values (38)	125917	20.6%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	484577	79.4%
Uppercase Letter	74299	12.2%
Space Separator	50146	8.2%
Dash Punctuation	1472	0.2%

Most frequent character per category

Value	Count	Frequency (%)
a	78760	16.3%
o	61554	12.7%
r	58565	12.1%
e	56680	11.7%
t	54194	11.2%
i	34322	7.1%
n	33353	6.9%
l	30274	6.2%
p	24153	5.0%
s	7683	1.6%
Other values (15)	45039	9.3%

Value	Count	Frequency (%)
M	26729	36.0%
A	25257	34.0%
C	2944	4.0%
K	2899	3.9%
P	2576	3.5%
S	2576	3.5%
N	2208	3.0%
D	1472	2.0%
B	1427	1.9%
F	736	1.0%
Other values (11)	5475	7.4%

Value	Count	Frequency (%)
	50146	100.0%

Value	Count	Frequency (%)
-	1472	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	558876	91.5%
Common	51618	8.5%

Most frequent character per script

Value	Count	Frequency (%)
a	78760	14.1%
o	61554	11.0%
r	58565	10.5%
e	56680	10.1%
t	54194	9.7%
i	34322	6.1%
n	33353	6.0%
l	30274	5.4%
M	26729	4.8%
A	25257	4.5%
Other values (36)	99188	17.7%

Value	Count	Frequency (%)
	50146	97.1%
-	1472	2.9%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	610494	100.0%

Most frequent character per block

Value	Count	Frequency (%)
a	78760	12.9%
o	61554	10.1%
r	58565	9.6%
e	56680	9.3%
t	54194	8.9%
	50146	8.2%
i	34322	5.6%
n	33353	5.5%
l	30274	5.0%
M	26729	4.4%
Other values (38)	125917	20.6%

iso_3166_2_code
Categorical

HIGH CARDINALITY
MISSING

Distinct	2224
Distinct (%)	0.3%
Missing	3531512
Missing (%)	82.1%
Memory size	32.8 MiB

KE-10	368
BR-GO	368
PL-PK	368
VN-54	368
FR-49	368
Other values (2219)	767361

Length

Max length	6
Median length	5
Mean length	5.191745721
Min length	4

Characters and Unicode

Total characters	3993496
Distinct characters	37
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	2 ?
Unique (%)	< 0.1%

Sample

1st row	AE-AZ
2nd row	AE-AZ
3rd row	AE-AZ
4th row	AE-AZ
5th row	AE-AZ

Value	Count	Frequency (%)
KE-10	368	< 0.1%
BR-GO	368	< 0.1%
PL-PK	368	< 0.1%
VN-54	368	< 0.1%
FR-49	368	< 0.1%
EC-T	368	< 0.1%
PE-LMA	368	< 0.1%
RO-BN	368	< 0.1%
ES-CC	368	< 0.1%
PE-LAL	368	< 0.1%
Other values (2214)	765521	17.8%
(Missing)	3531512	82.1%

Histogram of lengths of the category

Value	Count	Frequency (%)
ar-f	368	< 0.1%
fr-66	368	< 0.1%
it-at	368	< 0.1%
sk-bc	368	< 0.1%
in-dn	368	< 0.1%
it-62	368	< 0.1%
jp-03	368	< 0.1%
cz-ka	368	< 0.1%
ca-ab	368	< 0.1%
ch-sg	368	< 0.1%
Other values (2214)	765521	99.5%

Most occurring characters

Value	Count	Frequency (%)
-	769201	19.3%
B	179646	4.5%
S	167524	4.2%
R	166616	4.2%
G	163832	4.1%
T	161735	4.0%
I	156263	3.9%
N	147609	3.7%
C	146230	3.7%
E	145001	3.6%
Other values (27)	1789839	44.8%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	2590292	64.9%
Dash Punctuation	769201	19.3%
Decimal Number	634003	15.9%

Most frequent character per category

Value	Count	Frequency (%)
B	179646	6.9%
S	167524	6.5%
R	166616	6.4%
G	163832	6.3%
T	161735	6.2%
I	156263	6.0%
N	147609	5.7%
C	146230	5.6%
E	145001	5.6%
A	130373	5.0%
Other values (16)	1025463	39.6%

Value	Count	Frequency (%)
1	110872	17.5%
0	109522	17.3%
2	84690	13.4%
3	66125	10.4%
4	58790	9.3%
5	52134	8.2%
6	43778	6.9%
7	42616	6.7%
8	37363	5.9%
9	28113	4.4%

Value	Count	Frequency (%)
-	769201	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	2590292	64.9%
Common	1403204	35.1%

Most frequent character per script

Value	Count	Frequency (%)
B	179646	6.9%
S	167524	6.5%
R	166616	6.4%
G	163832	6.3%
T	161735	6.2%
I	156263	6.0%
N	147609	5.7%
C	146230	5.6%
E	145001	5.6%
A	130373	5.0%
Other values (16)	1025463	39.6%

Value	Count	Frequency (%)
-	769201	54.8%
1	110872	7.9%
0	109522	7.8%
2	84690	6.0%
3	66125	4.7%
4	58790	4.2%
5	52134	3.7%
6	43778	3.1%
7	42616	3.0%
8	37363	2.7%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	3993496	100.0%

Most frequent character per block

Value	Count	Frequency (%)
-	769201	19.3%
B	179646	4.5%
S	167524	4.2%
R	166616	4.2%
G	163832	4.1%
T	161735	4.0%
I	156263	3.9%
N	147609	3.7%
C	146230	3.7%
E	145001	3.6%
Other values (27)	1789839	44.8%

census_fips_code
Real number (ℝ_≥0)

MISSING

Distinct	2838
Distinct (%)	0.3%
Missing	3384928
Missing (%)	78.7%
Infinite	0
Infinite (%)	0.0%

Mean	30356.46021
Minimum	1001
Maximum	56045
Zeros	0
Zeros (%)	0.0%
Memory size	32.8 MiB

Quantile statistics

Minimum	1001
5-th percentile	5099
Q1	18105
median	29115
Q3	45051
95-th percentile	53075
Maximum	56045
Range	55044
Interquartile range (IQR)	26946

Descriptive statistics

Standard deviation	15299.02973
Coefficient of variation (CV)	0.5039793711
Kurtosis	-1.127910405
Mean	30356.46021
Median Absolute Deviation (MAD)	12012
Skewness	-0.07283810347
Sum	2.779999091 × 10¹⁰
Variance	234060310.5
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
27171	368	< 0.1%
37125	368	< 0.1%
13223	368	< 0.1%
42133	368	< 0.1%
37151	368	< 0.1%
26075	368	< 0.1%
48375	368	< 0.1%
6037	368	< 0.1%
41029	368	< 0.1%
29213	368	< 0.1%
Other values (2828)	912105	21.2%
(Missing)	3384928	78.7%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1001	362	< 0.1%
1003	368	< 0.1%
1005	343	< 0.1%
1007	343	< 0.1%
1009	362	< 0.1%

Value	Count	Frequency (%)
56045	244	< 0.1%
56043	251	< 0.1%
56041	343	< 0.1%
56039	343	< 0.1%
56037	362	< 0.1%

place_id
Categorical

HIGH CARDINALITY

Distinct	13276
Distinct (%)	0.3%
Missing	736
Missing (%)	< 0.1%
Memory size	32.8 MiB

ChIJA-Vp4NdDXDkRni-uywd-c1o	368
ChIJG-W5i09HU4YRiUwVqIdjhGw	368
ChIJCRlcH4ezhIARAFpUT3LUXyQ	368
ChIJlXSYuxF9pgARGX5qiWqW7nk	368
ChIJjVxms-FrAYcRwPvQAzP5JaQ	368
Other values (13271)	4298137

Length

Max length	27
Median length	27
Mean length	27
Min length	27

Characters and Unicode

Total characters	116099379
Distinct characters	64
Distinct categories	5 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	8 ?
Unique (%)	< 0.1%

Sample

1st row	ChIJvRKrsd9IXj4RpwoIwFYv0zM
2nd row	ChIJvRKrsd9IXj4RpwoIwFYv0zM
3rd row	ChIJvRKrsd9IXj4RpwoIwFYv0zM
4th row	ChIJvRKrsd9IXj4RpwoIwFYv0zM
5th row	ChIJvRKrsd9IXj4RpwoIwFYv0zM

Value	Count	Frequency (%)
ChIJA-Vp4NdDXDkRni-uywd-c1o	368	< 0.1%
ChIJG-W5i09HU4YRiUwVqIdjhGw	368	< 0.1%
ChIJCRlcH4ezhIARAFpUT3LUXyQ	368	< 0.1%
ChIJlXSYuxF9pgARGX5qiWqW7nk	368	< 0.1%
ChIJjVxms-FrAYcRwPvQAzP5JaQ	368	< 0.1%
ChIJu-SH28MJxkcRJYI2wf63IME	368	< 0.1%
ChIJezSAEFMr1BIRq1kgW7rDxro	368	< 0.1%
ChIJoyODwTLIV5QR5GZiwFe2FL8	368	< 0.1%
ChIJE4nvwn3UkZURFAOLNknhvCQ	368	< 0.1%
ChIJ7Rc_pRMuH0cRQMo4lLefAgM	368	< 0.1%
Other values (13266)	4296297	99.9%
(Missing)	736	< 0.1%

Histogram of lengths of the category

Value	Count	Frequency (%)
chijd9w2lenaiograyhzlrtppyy	368	< 0.1%
chijmxk1pawyiw0r9rwem_sscfq	368	< 0.1%
chijj614yjyawrqrvaumrvoqy1u	368	< 0.1%
chij5q-ziccniocrbgkeukqw_ys	368	< 0.1%
chijd8t--swfwxqrlpz1nfcdn5y	368	< 0.1%
chij2q9mibf0qygrdf2if6v8nkc	368	< 0.1%
chijb8o3hhcfddkrjj7wl7bboei	368	< 0.1%
chijc1b7fc3s3ikru6ik0rybvt4	368	< 0.1%
chijfsxg-ercpgar4mudwyceiee	368	< 0.1%
chijl1dm9flnc0crykkuzg-vaam	368	< 0.1%
Other values (13266)	4296297	99.9%

Most occurring characters

Value	Count	Frequency (%)
I	6189468	5.3%
R	5765578	5.0%
J	5650376	4.9%
h	5568893	4.8%
C	5556987	4.8%
c	2554210	2.2%
Q	2459288	2.1%
A	2340226	2.0%
g	2262437	1.9%
Y	2220616	1.9%
Other values (54)	75531300	65.1%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	56770019	48.9%
Lowercase Letter	41736825	35.9%
Decimal Number	15023281	12.9%
Connector Punctuation	1292450	1.1%
Dash Punctuation	1276804	1.1%

Most frequent character per category

Value	Count	Frequency (%)
I	6189468	10.9%
R	5765578	10.2%
J	5650376	10.0%
C	5556987	9.8%
Q	2459288	4.3%
A	2340226	4.1%
Y	2220616	3.9%
U	2170329	3.8%
E	1899681	3.3%
M	1866890	3.3%
Other values (16)	20650580	36.4%

Value	Count	Frequency (%)
h	5568893	13.3%
c	2554210	6.1%
g	2262437	5.4%
k	2035679	4.9%
o	1814585	4.3%
w	1771753	4.2%
s	1616151	3.9%
x	1554392	3.7%
z	1411150	3.4%
a	1345561	3.2%
Other values (16)	19802014	47.4%

Value	Count	Frequency (%)
4	2007435	13.4%
0	1896556	12.6%
8	1627515	10.8%
5	1514607	10.1%
1	1361479	9.1%
2	1360623	9.1%
3	1358992	9.0%
7	1337900	8.9%
6	1304676	8.7%
9	1253498	8.3%

Value	Count	Frequency (%)
_	1292450	100.0%

Value	Count	Frequency (%)
-	1276804	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	98506844	84.8%
Common	17592535	15.2%

Most frequent character per script

Value	Count	Frequency (%)
I	6189468	6.3%
R	5765578	5.9%
J	5650376	5.7%
h	5568893	5.7%
C	5556987	5.6%
c	2554210	2.6%
Q	2459288	2.5%
A	2340226	2.4%
g	2262437	2.3%
Y	2220616	2.3%
Other values (42)	57938765	58.8%

Value	Count	Frequency (%)
4	2007435	11.4%
0	1896556	10.8%
8	1627515	9.3%
5	1514607	8.6%
1	1361479	7.7%
2	1360623	7.7%
3	1358992	7.7%
7	1337900	7.6%
6	1304676	7.4%
_	1292450	7.3%
Other values (2)	2530302	14.4%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	116099379	100.0%

Most frequent character per block

Value	Count	Frequency (%)
I	6189468	5.3%
R	5765578	5.0%
J	5650376	4.9%
h	5568893	4.8%
C	5556987	4.8%
c	2554210	2.2%
Q	2459288	2.1%
A	2340226	2.0%
g	2262437	1.9%
Y	2220616	1.9%
Other values (54)	75531300	65.1%

date
Categorical

HIGH CARDINALITY

Distinct	368
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	32.8 MiB

2020-11-25	13147
2020-11-27	13144
2020-11-11	13137
2020-11-24	13135
2020-07-09	13131
Other values (363)	4235019

Length

Max length	10
Median length	10
Mean length	10
Min length	10

Characters and Unicode

Total characters	43007130
Distinct characters	11
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	2020-02-15
2nd row	2020-02-16
3rd row	2020-02-17
4th row	2020-02-18
5th row	2020-02-19

Value	Count	Frequency (%)
2020-11-25	13147	0.3%
2020-11-27	13144	0.3%
2020-11-11	13137	0.3%
2020-11-24	13135	0.3%
2020-07-09	13131	0.3%
2020-12-29	13130	0.3%
2020-11-18	13128	0.3%
2021-01-27	13128	0.3%
2020-06-23	13128	0.3%
2020-12-30	13127	0.3%
Other values (358)	4169378	96.9%

Histogram of lengths of the category

Value	Count	Frequency (%)
2020-11-25	13147	0.3%
2020-11-27	13144	0.3%
2020-11-11	13137	0.3%
2020-11-24	13135	0.3%
2020-07-09	13131	0.3%
2020-12-29	13130	0.3%
2020-11-18	13128	0.3%
2021-01-27	13128	0.3%
2020-06-23	13128	0.3%
2020-12-30	13127	0.3%
Other values (358)	4169378	96.9%

Most occurring characters

Value	Count	Frequency (%)
0	13220183	30.7%
2	11170627	26.0%
-	8601426	20.0%
1	4438722	10.3%
3	978631	2.3%
7	803024	1.9%
6	797214	1.9%
5	782610	1.8%
4	770271	1.8%
9	730801	1.7%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	34405704	80.0%
Dash Punctuation	8601426	20.0%

Most frequent character per category

Value	Count	Frequency (%)
0	13220183	38.4%
2	11170627	32.5%
1	4438722	12.9%
3	978631	2.8%
7	803024	2.3%
6	797214	2.3%
5	782610	2.3%
4	770271	2.2%
9	730801	2.1%
8	713621	2.1%

Value	Count	Frequency (%)
-	8601426	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	43007130	100.0%

Most frequent character per script

Value	Count	Frequency (%)
0	13220183	30.7%
2	11170627	26.0%
-	8601426	20.0%
1	4438722	10.3%
3	978631	2.3%
7	803024	1.9%
6	797214	1.9%
5	782610	1.8%
4	770271	1.8%
9	730801	1.7%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	43007130	100.0%

Most frequent character per block

Value	Count	Frequency (%)
0	13220183	30.7%
2	11170627	26.0%
-	8601426	20.0%
1	4438722	10.3%
3	978631	2.3%
7	803024	1.9%
6	797214	1.9%
5	782610	1.8%
4	770271	1.8%
9	730801	1.7%

retail_and_recreation
Real number (ℝ)

MISSING

Distinct	425
Distinct (%)	< 0.1%
Missing	1598804
Missing (%)	37.2%
Infinite	0
Infinite (%)	0.0%

Mean	-23.61628537
Minimum	-100
Maximum	545
Zeros	39043
Zeros (%)	0.9%
Memory size	32.8 MiB

Quantile statistics

Minimum	-100
5-th percentile	-75
Q1	-41
median	-20
Q3	-5
95-th percentile	14
Maximum	545
Range	645
Interquartile range (IQR)	36

Descriptive statistics

Standard deviation	27.64471363
Coefficient of variation (CV)	-1.170578404
Kurtosis	2.771897863
Mean	-23.61628537
Median Absolute Deviation (MAD)	17
Skewness	-0.002345781175
Sum	-63809054
Variance	764.2301919
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
-10	45531	1.1%
-11	45362	1.1%
-12	45321	1.1%
-8	45313	1.1%
-9	45087	1.0%
-13	45021	1.0%
-14	44930	1.0%
-7	44507	1.0%
-6	44343	1.0%
-16	44178	1.0%
Other values (415)	2252316	52.4%
(Missing)	1598804	37.2%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-100	198	< 0.1%
-99	83	< 0.1%
-98	447	< 0.1%
-97	948	< 0.1%
-96	1515	< 0.1%

Value	Count	Frequency (%)
545	1	< 0.1%
533	1	< 0.1%
527	2	< 0.1%
512	1	< 0.1%
507	1	< 0.1%

grocery_and_pharmacy
Real number (ℝ)

MISSING
ZEROS

Distinct	537
Distinct (%)	< 0.1%
Missing	1694251
Missing (%)	39.4%
Infinite	0
Infinite (%)	0.0%

Mean	-3.029733409
Minimum	-100
Maximum	615
Zeros	69501
Zeros (%)	1.6%
Memory size	32.8 MiB

Quantile statistics

Minimum	-100
5-th percentile	-45
Q1	-14
median	-2
Q3	9
95-th percentile	33
Maximum	615
Range	715
Interquartile range (IQR)	23

Descriptive statistics

Standard deviation	24.57067163
Coefficient of variation (CV)	-8.109846087
Kurtosis	11.80407405
Mean	-3.029733409
Median Absolute Deviation (MAD)	11
Skewness	0.4747040403
Sum	-7896885
Variance	603.7179044
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	69501	1.6%
-1	68734	1.6%
-2	68528	1.6%
1	67801	1.6%
2	66858	1.6%
-3	66391	1.5%
-4	64922	1.5%
3	64573	1.5%
-5	63172	1.5%
4	61890	1.4%
Other values (527)	1944092	45.2%
(Missing)	1694251	39.4%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-100	152	< 0.1%
-99	1	< 0.1%
-98	45	< 0.1%
-97	250	< 0.1%
-96	654	< 0.1%

Value	Count	Frequency (%)
615	1	< 0.1%
538	1	< 0.1%
533	1	< 0.1%
527	1	< 0.1%
524	1	< 0.1%

parks
Real number (ℝ)

MISSING

Distinct	855
Distinct (%)	< 0.1%
Missing	2235583
Missing (%)	52.0%
Infinite	0
Infinite (%)	0.0%

Mean	-10.37651237
Minimum	-100
Maximum	1206
Zeros	19161
Zeros (%)	0.4%
Memory size	32.8 MiB

Quantile statistics

Minimum	-100
5-th percentile	-78
Q1	-43
median	-18
Q3	10
95-th percentile	83
Maximum	1206
Range	1306
Interquartile range (IQR)	53

Descriptive statistics

Standard deviation	53.79536302
Coefficient of variation (CV)	-5.184339504
Kurtosis	14.7527523
Mean	-10.37651237
Median Absolute Deviation (MAD)	26
Skewness	2.400233603
Sum	-21428847
Variance	2893.941082
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
-27	21323	0.5%
-25	21281	0.5%
-21	21199	0.5%
-22	21140	0.5%
-24	21140	0.5%
-26	21125	0.5%
-29	21111	0.5%
-28	21089	0.5%
-20	21012	0.5%
-18	21001	0.5%
Other values (845)	1853709	43.1%
(Missing)	2235583	52.0%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-100	3634	0.1%
-99	288	< 0.1%
-98	836	< 0.1%
-97	1183	< 0.1%
-96	1540	< 0.1%

Value	Count	Frequency (%)
1206	1	< 0.1%
1187	1	< 0.1%
1146	1	< 0.1%
1136	1	< 0.1%
1113	1	< 0.1%

transit_stations
Real number (ℝ)

MISSING

Distinct	540
Distinct (%)	< 0.1%
Missing	2127730
Missing (%)	49.5%
Infinite	0
Infinite (%)	0.0%

Mean	-27.43854002
Minimum	-100
Maximum	554
Zeros	22407
Zeros (%)	0.5%
Memory size	32.8 MiB

Quantile statistics

Minimum	-100
5-th percentile	-73
Q1	-48
median	-28
Q3	-8
95-th percentile	18
Maximum	554
Range	654
Interquartile range (IQR)	40

Descriptive statistics

Standard deviation	29.92665808
Coefficient of variation (CV)	-1.090679681
Kurtosis	7.340301756
Mean	-27.43854002
Median Absolute Deviation (MAD)	20
Skewness	0.9435085961
Sum	-59623481
Variance	895.6048636
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
-35	28940	0.7%
-29	28919	0.7%
-33	28859	0.7%
-32	28790	0.7%
-30	28761	0.7%
-28	28734	0.7%
-34	28575	0.7%
-36	28575	0.7%
-31	28495	0.7%
-25	28338	0.7%
Other values (530)	1885997	43.9%
(Missing)	2127730	49.5%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-100	1778	< 0.1%
-99	7	< 0.1%
-98	74	< 0.1%
-97	254	< 0.1%
-96	526	< 0.1%

Value	Count	Frequency (%)
554	1	< 0.1%
524	1	< 0.1%
520	1	< 0.1%
506	1	< 0.1%
505	1	< 0.1%

workplaces
Real number (ℝ)

MISSING
ZEROS

Distinct	325
Distinct (%)	< 0.1%
Missing	198009
Missing (%)	4.6%
Infinite	0
Infinite (%)	0.0%

Mean	-20.03532012
Minimum	-100
Maximum	260
Zeros	67235
Zeros (%)	1.6%
Memory size	32.8 MiB

Quantile statistics

Minimum	-100
5-th percentile	-57
Q1	-32
median	-19
Q3	-6
95-th percentile	9
Maximum	260
Range	360
Interquartile range (IQR)	26

Descriptive statistics

Standard deviation	20.13046196
Coefficient of variation (CV)	-1.004748706
Kurtosis	0.9715821669
Mean	-20.03532012
Median Absolute Deviation (MAD)	13
Skewness	-0.3969940416
Sum	-82198988
Variance	405.2354986
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
-22	85427	2.0%
-21	85364	2.0%
-20	85349	2.0%
-23	84869	2.0%
-19	84833	2.0%
-24	84831	2.0%
-18	84654	2.0%
-17	84019	2.0%
-16	83089	1.9%
-25	82891	1.9%
Other values (315)	3257378	75.7%
(Missing)	198009	4.6%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-100	28	< 0.1%
-99	8	< 0.1%
-97	6	< 0.1%
-96	2	< 0.1%
-95	5	< 0.1%

Value	Count	Frequency (%)
260	1	< 0.1%
258	1	< 0.1%
257	1	< 0.1%
254	1	< 0.1%
248	1	< 0.1%

residential
Real number (ℝ)

MISSING
ZEROS

Distinct	107
Distinct (%)	< 0.1%
Missing	1798617
Missing (%)	41.8%
Infinite	0
Infinite (%)	0.0%

Mean	9.331561219
Minimum	-46
Maximum	65
Zeros	91313
Zeros (%)	2.1%
Memory size	32.8 MiB

Quantile statistics

Minimum	-46
5-th percentile	-1
Q1	4
median	8
Q3	14
95-th percentile	24
Maximum	65
Range	111
Interquartile range (IQR)	10

Descriptive statistics

Standard deviation	7.789884981
Coefficient of variation (CV)	0.8347890346
Kurtosis	1.163721839
Mean	9.331561219
Median Absolute Deviation (MAD)	5
Skewness	0.7758349242
Sum	23348462
Variance	60.68230802
Monotocity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
7	148902	3.5%
6	146996	3.4%
8	146372	3.4%
5	140094	3.3%
9	138896	3.2%
10	130285	3.0%
4	125221	2.9%
11	119543	2.8%
3	112310	2.6%
12	108413	2.5%
Other values (97)	1185064	27.6%
(Missing)	1798617	41.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
-46	4	< 0.1%
-45	2	< 0.1%
-43	1	< 0.1%
-40	1	< 0.1%
-39	1	< 0.1%

Value	Count	Frequency (%)
65	1	< 0.1%
64	2	< 0.1%
63	1	< 0.1%
62	1	< 0.1%
61	1	< 0.1%

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

The dendrogram allows you to more fully correlate variable completion, revealing trends deeper than the pairwise ones visible in the correlation heatmap.

First rows

	country_region_code	country_region	sub_region_1	sub_region_2	metro_area	iso_3166_2_code	census_fips_code	place_id	date	retail_and_recreation	grocery_and_pharmacy	parks	transit_stations	workplaces	residential
0	AE	United Arab Emirates	NaN	NaN	NaN	NaN	NaN	ChIJvRKrsd9IXj4RpwoIwFYv0zM	2020-02-15	0.0	4.0	5.0	0.0	2.0	1.0
1	AE	United Arab Emirates	NaN	NaN	NaN	NaN	NaN	ChIJvRKrsd9IXj4RpwoIwFYv0zM	2020-02-16	1.0	4.0	4.0	1.0	2.0	1.0
2	AE	United Arab Emirates	NaN	NaN	NaN	NaN	NaN	ChIJvRKrsd9IXj4RpwoIwFYv0zM	2020-02-17	-1.0	1.0	5.0	1.0	2.0	1.0
3	AE	United Arab Emirates	NaN	NaN	NaN	NaN	NaN	ChIJvRKrsd9IXj4RpwoIwFYv0zM	2020-02-18	-2.0	1.0	5.0	0.0	2.0	1.0
4	AE	United Arab Emirates	NaN	NaN	NaN	NaN	NaN	ChIJvRKrsd9IXj4RpwoIwFYv0zM	2020-02-19	-2.0	0.0	4.0	-1.0	2.0	1.0
5	AE	United Arab Emirates	NaN	NaN	NaN	NaN	NaN	ChIJvRKrsd9IXj4RpwoIwFYv0zM	2020-02-20	-2.0	1.0	6.0	1.0	1.0	1.0
6	AE	United Arab Emirates	NaN	NaN	NaN	NaN	NaN	ChIJvRKrsd9IXj4RpwoIwFYv0zM	2020-02-21	-3.0	2.0	6.0	0.0	-1.0	1.0
7	AE	United Arab Emirates	NaN	NaN	NaN	NaN	NaN	ChIJvRKrsd9IXj4RpwoIwFYv0zM	2020-02-22	-2.0	2.0	4.0	-2.0	3.0	1.0
8	AE	United Arab Emirates	NaN	NaN	NaN	NaN	NaN	ChIJvRKrsd9IXj4RpwoIwFYv0zM	2020-02-23	-1.0	3.0	3.0	-1.0	4.0	1.0
9	AE	United Arab Emirates	NaN	NaN	NaN	NaN	NaN	ChIJvRKrsd9IXj4RpwoIwFYv0zM	2020-02-24	-3.0	0.0	5.0	-1.0	3.0	1.0

Last rows

	country_region_code	country_region	sub_region_1	sub_region_2	metro_area	iso_3166_2_code	census_fips_code	place_id	date	retail_and_recreation	grocery_and_pharmacy	parks	transit_stations	workplaces	residential
4300703	ZW	Zimbabwe	Midlands Province	Kwekwe	NaN	NaN	NaN	ChIJRcIZ3-FJNBkRRsj55IcLpfU	2021-02-03	NaN	NaN	NaN	NaN	-29.0	NaN
4300704	ZW	Zimbabwe	Midlands Province	Kwekwe	NaN	NaN	NaN	ChIJRcIZ3-FJNBkRRsj55IcLpfU	2021-02-04	NaN	NaN	NaN	NaN	-31.0	NaN
4300705	ZW	Zimbabwe	Midlands Province	Kwekwe	NaN	NaN	NaN	ChIJRcIZ3-FJNBkRRsj55IcLpfU	2021-02-05	NaN	NaN	NaN	NaN	-27.0	NaN
4300706	ZW	Zimbabwe	Midlands Province	Kwekwe	NaN	NaN	NaN	ChIJRcIZ3-FJNBkRRsj55IcLpfU	2021-02-08	NaN	NaN	NaN	NaN	-30.0	NaN
4300707	ZW	Zimbabwe	Midlands Province	Kwekwe	NaN	NaN	NaN	ChIJRcIZ3-FJNBkRRsj55IcLpfU	2021-02-09	NaN	NaN	NaN	NaN	-19.0	NaN
4300708	ZW	Zimbabwe	Midlands Province	Kwekwe	NaN	NaN	NaN	ChIJRcIZ3-FJNBkRRsj55IcLpfU	2021-02-10	NaN	NaN	NaN	NaN	-25.0	NaN
4300709	ZW	Zimbabwe	Midlands Province	Kwekwe	NaN	NaN	NaN	ChIJRcIZ3-FJNBkRRsj55IcLpfU	2021-02-11	NaN	NaN	NaN	NaN	-28.0	NaN
4300710	ZW	Zimbabwe	Midlands Province	Kwekwe	NaN	NaN	NaN	ChIJRcIZ3-FJNBkRRsj55IcLpfU	2021-02-12	NaN	NaN	NaN	NaN	-25.0	NaN
4300711	ZW	Zimbabwe	Midlands Province	Kwekwe	NaN	NaN	NaN	ChIJRcIZ3-FJNBkRRsj55IcLpfU	2021-02-15	NaN	NaN	NaN	NaN	-31.0	NaN
4300712	ZW	Zimbabwe	Midlands Province	Kwekwe	NaN	NaN	NaN	ChIJRcIZ3-FJNBkRRsj55IcLpfU	2021-02-16	NaN	NaN	NaN	NaN	-24.0	NaN

Overview

Variables

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Most occurring characters

Most occurring categories

Most frequent character per category

Most occurring scripts

Most frequent character per script

Most occurring blocks

Most frequent character per block

Interactions

Correlations

Pearson's r

Spearman's ρ

Kendall's τ

Phik (φk)

Missing values

Sample

First rows

Last rows